Welcome to RoofCOST Estimator
Roofing Installation Cost Estimator for Excel.
Copyright © 2003. CPR International, Inc. All rights reserved.

CPR International, Inc.
Internet:  http://www.cprsoft.com 
Email:  cpr@cprsoft.com 
Registration:  Register Now 

Getting Started
Introduction
RoofCOST Estimator is an MS Excel based, easy-to-use software tool for estimating roofing materials and installation costs. 
RoofCOST Estimator is distributed in two editions. 
The trial edition is licensed for and functional for a maximum period of 7 days, beyond which a user has to obtain an Authorization Code upon payment of $39.00 registration fee. The trial edition may be distributed free.
The registered edition does not need an Authorization Code to run in full functional mode. Since it is licensed for one user, it is illegal to make and distribute copies of the registered edition.

Trial Edition
RoofCOST Estimator 7-day trial edition is distributed free. Single-user registration for the full feature version is $39.00. 
We update and improve RoofCOST Estimator frequently. With registration, we provide several benefits including free lifetime program updates and free technical support. Multi-user, company and site licensing programs are also available upon request.
For more information on benefits of registration, Click here.

Registered Edition
This is the fully functional edition and does not require an Authorization Code. If you have purchased this edition of RoofCOST Estimator, the system shall indicate that it is a registered product. Since this edition is licensed for one user, it is illegal to make and distribute copies of this edition.
Benefits of registration:
•	No Authorization Code required
•	Permission to access and customize built-in data
•	Free unlimited technical support services
•	Free lifetime program and cost data updates

How To Register
Register and unlock the full features of the program as follows:
1. Click on the following to register now and download the latest version of RoofCOST Estimator.
	Register Now 
2.  Visit our website and register online at http://www.cprsoft.com/RoofCOST.htm 
3.  Mail registration fee payment of $39.00 to: 

CPR International, Inc. 
P.O. Box 6394
Folsom, CA 95763 
4.  Register by phone at 916-351-9782.
5.  Register by Email at:
	cpr@cprsoft.com 
Be sure to indicate your name, address, email and phone number and method of payment.

Who Can Benefit
RoofCOST Estimator is designed for roofing contractors, decorators, builders, remodelers, and do-it-yourselfers. Thanks to user-definable cost category and activity definitions, RoofCOST Estimator can be used in a wide variety of construction projects.

Excel Version Compatibility
RoofCOST Estimator is designed for use with Excel 97-2000 and above. It works with Windows 95/98/Me/2000/NT/XP.

Excel's Built-in Macro Protection
Excel's "High" level macro security will not allow Excel macros to run on the computer. The standard setting is "Medium". If your setting is at "High", you should switch to "Medium" security in order to run RoofCOST Estimator.
Excel's "Medium" level macro security warns users when files with macros are opened. At this point, click on "Enable Macros" button. 
To change level of security:
•	In the Tools menu, point to Macro, and then click Security.
•	Click the Security Level tab, and then click the ‘Medium’ option.

At startup, be sure to click on ‘Enable Macros’ button of Excel’s security window.

Program Features
General
Cost estimating is a hard and time-consuming process. It is particularly so for flooring estimating with many variables and takeoffs. Often, flooring contractors spend an enormous amount of time to create estimates and prepare quotations. RoofCOST Estimator addresses this hardship in a productive manner. It helps to save time and save money. 
Because RoofCOST Estimator is based on Microsoft Excel, you already know how to use it. You also know it is easy from start to finish. In fact, you can prepare a detailed and accurate cost estimate within minutes including formatted reports and quotations. 
RoofCOST includes cost data for flooring materials and installation. And, the best part is, you can customize this data easily to suit your business.
Important Note: All data input and maintenance functions are program controlled and you do not need to use Excel functions. Because RoofCOST Estimator is based on predefined structures in the worksheets, do not use Excel functions to erase table headers, add rows and columns manually. Instead, use the built-in menu functions.

How RoofCOST Estimator Works
RoofCOST Estimator is a cost estimating program based on locations (or areas). It includes a handy takeoff tool for computing areas. It has the flexibility for the user to modify takeoff depending on actual conditions.
To setup of an estimate file, proceed as follows:
1.	Open the RoofCOST.xls file.
2.	Add new work items tied to Sections. 
3.	At the Work Item estimate window, enter Section, Description Unit and Unit Cost. To lookup and select a work item from the CostData sheet, click on the Lookup button. Then select the work item. Use the area calculator to compute areas. 
4.	Repeat with additional work item estimates.
5.	At any time or after an estimate file is complete, save the file in another name that will be easy to identify. Example: When you start RoofCOST.xls and setup a job, save this file, for example, as Est2218.xls. Then, this new, self-contained file shall represent all RoofCOST Estimator functionalities as well as the data for the project.  

To maintain an estimate file, proceed as follows:
1.	Open the estimate file.
2.	Place your mouse on the row representing the work item you wish to edit.
3.	Click on Edit Item submenu from RoofCOST menu.
4.	Edit the detail from Work Item window.

To delete a Work Item, proceed as follows:
1.	Place your mouse on the row representing the work item you wish to edit.
2.	Click on Delete Row/Item from the RoofCOST menu. Excel will delete the highlighted row.

Each Work Item is listed in the Estimate worksheet. At any time, a user can create estimate report and estimate quote.

Creating Reports
RoofCOST Estimator provides instant, on-screen Estimate and Quote reports by selection from the RoofCOST Menu. 
It is recommended that data entries are finalized for a period before creating reports. This will ensure that all data is up to date at time of reporting.
RoofCOST Estimator creates each report in a separate Excel worksheet called Book1, Book 2 etc. After viewing the report, you should save it in another name. Note that this will save only the displayed report and not the original estimate file.
 Printing Reports
At any time, you can create Estimate and Quote reports by selecting the appropriate submenu item from the RoofCOST menu. When RoofCOST Estimator creates the report, use Excel’s printing functions under the File Menu to print reports on the printer.  
 
Worksheets
RoofCOST Estimator contains the following worksheet. Note that access to some of these worksheets is restricted for Trial edition users.

Estimate Worksheet
RoofCOST Estimator lists all Work Item related entries as a row in the Estimate worksheet. Note: RoofCOST Estimator maintains this worksheet automatically. Therefore, do not edit cells or add or delete rows and columns from this worksheet directly. This will cause errors.

JobInfo Worksheet
This worksheet contains information on the customer, billing, payment schedule, etc. RoofCOST Estimator user shall fill out and customize this information.

OhandP Worksheet
This worksheet contains contractor’s overhead and profit to be applied. This data is user modifiable.

CostData Worksheet
This worksheet contains cost information on flooring cost items. RoofCOST Estimator user may edit the entries. However, be careful to follow worksheet edit information on the worksheet.

QuickHelp Worksheet
This worksheet lists a limited selection of FAQ’s.

RoofCOST Menu
RoofCOST Custom Menu
When you open the RoofCOST.xls file (or the same file saved under a different name), the program will add a temporary menu item called "RoofCOST" to Excel’s Main Menu. All functions can be carried out using the temporary RoofCOST menu item. When the program file is closed, this temporary Excel menu item shall be removed. 
RoofCOST menu item shall not be available whenever you switch to another workbook including workbooks that contain estimate and quote reports.

RoofCOST Menu Items
Add Work Item
Click on this submenu under RoofCOST to add a new work item to the estimate file. RoofCOST Estimator shall open the Work Item window for data entries.

Edit Item
Place the mouse cursor on a row of data in the Estimate worksheet, then click on this submenu under RoofCOST to edit the work item. RoofCOST Estimator shall open the Work Item window for data edits.

Delete Row/Item
Place your mouse on the row representing the work item you wish to edit. Click on Delete Row/Item from the RoofCOST menu. Excel will delete the highlighted row.

Clear Estimate
This function clears all data (except the first two rows for table headers) in the Estimate worksheet. Because clearing these worksheets is an irreversible process, please be sure to save a copy of the file as backup. Do not delete the header rows of these worksheets manually.

Create Report
RoofCOST Estimator will create instant, on-screen report by selection from the RoofCOST Menu. The report will be generated on a new workbook.

Create Quote
RoofCOST Estimator will create instant, on-screen Price Quotation report by selection from the RoofCOST Menu. The report will be generated on a new workbook. You can modify and print the report for transmitting to a customer.
Show RoofCOST Help
Click on this submenu under RoofCOST to activate the Help system.

About RoofCOST Estimator
Click on this submenu under RoofCOST to display the About dialog.

Other
Copyrights
Microsoft, Excel, MS Excel are registered trademarks of Microsoft Corporation.
RoofCOST Estimator is a trademark of CPR International, Inc.

Happy Estimating!
And, don't forget to register your RoofCOST Estimator with us so we can keep you updated for new versions, improvements and exciting new products.
CPR International, Inc.
P.O. Box 6394
Folsom, CA 95763
cpr@cprsoft.com